cd "C:\Dropbox\GeneticsProject (1)\REStat\data\ipums_1970"
set more off

*** country code for birthplace of parents
*** father
import excel "country_birthplace_bridge.xlsx", ///
	sheet("fbpld") cellrange(D1) firstrow clear
destring  fbpld, force replace

keep if countrycode~=""
save fbpld, replace 

import excel "country_birthplace_bridge.xlsx", ///
	sheet("mbpld") cellrange(D1) firstrow clear
destring  mbpld, force replace

keep if countrycode~=""
save mbpld, replace 



